gsm_comment table — gsmcm
This table lists generic comments that can be linked to any entity.
Table 9–3 lists the table’s FLA, fields, and foreign keys.
Table 9–3: gsm_comment table information
|
Table FLA
|
Fields (data type)
|
Foreign keys
|
|
gsmcm
|
comment_obj (Decimal)
owning_entity_mnemonic (Character)
owning_reference (Character)
owning_obj (Decimal)
category_obj (Decimal)
comment_text (Character)
auto_display (Logical)
print_option_tlas (Character)
expiry_date (Date)
comment_description (Character)
last_updated_by_user (Character)
last_updated_date (Date)
|
category_obj
owning_obj
|
Table 9–4 gives details of the table’s indexes.
Table 9–4: gsm_comment index information
|
Index name
|
Elements
|
Type
|
|
XPKgsm_comment
|
comment_obj
|
Primary Unique
|
|
XAK1gsm_comment
|
category_obj
owning_reference
comment_obj
owning_entity_mnemonic
|
Unique
|
|
XIE1gsm_comment
|
comment_description
|
Nonunique
|
|
XIE2gsm_comment
|
owning_reference
auto_display
|
Nonunique
|
|
XIE3gsm_comment
|
owning_entity_mnemonic
owning_reference
|
Nonunique
|
|
XIE4gsm_comment
|
last_updated_by_user
|
Nonunique
|
|
XIE5gsm_comment
|
last_updated_date
|
Nonunique
|